The following issues are available in the WinTree version 8439. This version will be available from january 2015
![]() |
Important information for all WinTree users
Database Conversion
The conversion of all databases will start automatically following the installation of the new version of WinTree. The database is the file in which the company data such as customers, sales orders, deliveries and invoices is stored. During the conversion, the data from the database is adapted in line with the latest version of the software. Where necessary, new tables are added or existing tables extended.
The current database used in WinTree is SQLAnywhere version 10. After installing this software update, the database will be converted to database version 16. Please note, compared to previous installations, it will now take longer to convert the database(s) (current season, financial and historical). Where as a database conversion would previously take 15 minutes, it will now take 2-3 times as long.
During database conversion it will NOT be possible to work in WinTree and also not in the current season when the historical database is being converted. |
Enquiry: Change Suppliers view
In Stock items -> Enquiry you can now change the view to customers. All customers will then be shown directly on the tab page Selection. In the past when the Suppliers view was selected, a supplier name always had to be selected first. It is now also possible to display all suppliers on screen when you select the Suppliers view. This option is set using parameter 2262.
Make only price fields mutable via authorisation
The menu Stock items -> Maintain Stock items can be made inaccessible or 'Read only' via authorisation. In the basic information Roles it is now possible to make the price fields mutable without affecting any of the other fields.
Stock enquiry; extra tab page Alterations
Using parameter 2227 (to be configured by TSD) an extra tab page can be made available in the Stock enquiry menu. The stock alteration of the selected article are displayed on this tab. The tab also has a special column referred to as 'Special balance' in which TSD can calculate a separate balance based on the alterations.
The tab shows the same data as the screen that can be opened via the Stock -> Maintain Stock -> Maintain stock per Location (or Plant) -> button [Options] -> Stock alterations.
Negative stock; now in conjunction with basic module configuration (BASIC)
Due to a change relating to an improved origin registration, it was temporarily impossible to negatively allocate stock when only using the WinTree® basic module. This has been resolved. WinTree can now be assigned negative stock quantities by default. If the allocated quantity exceeds the quantity in stock, you can now use Parameter 2266. The default value of the parameter is 1.
Stock alterations: warning if purchased batches are altered
When changing an original purchased batch, WinTree displays a warning if no choice is made to adjust the purchase. Parameter 2249 can be used to configure whether this warning has to be displayed. The warning is displayed when this parameter is set to value 1 (default). When set to value 0, the warning is no longer shown.
Maintain stock: Suppress 0-batches on the basis of entry date
Parameter 38 can be used to configure whether batches with a value of 0 will be displayed. It is now also possible to suppress 0-batches on the basis of the entry date. Parameter 2245, set to value 1, will display all 0-batches with a entry date before the beginning of the season.
Record initial stock levels before end of season (BASIC)
For a number of companies, an important Wintree feature is monitoring the flow of stock. Alterations of the stock during the season can be identified on the basis of various documents. The problem continues to be the initial stock levels at a point in time X.
By counting back, an initial level can be determined, but this is a difficult calculation. In order to increase the level of clarity an option is available which can be used to take a 'snapshot' of the stock at any given point in time. This snapshot exports the stock level when exported to Excel. If these Excel sheets are saved, it is always possible to find out what the stock was on a certain date in the past. This snapshot option is also part of the standard Year end procedure. See issue 18005.
Please contact TSD if you want to use this 'snapshot' option several times a year.
Year end procedure: Extra Options available (BASIC)
A number of extra options are now available in the wizard for the year end:
- Extra checkbox 'Delete allocations of sales lines which are remain’ on the Sales Orders tab. This allows the alterations of all remain sales lines to be deleted so that the entire stock can be deleted or set to 0.
- Extra checkbox ‘Record current stock level separately’ on the Stock tab. This enables the current stock level, in other words before everything has been cleaned up, to be exported to Excel. See also issue 18072.
Import stock from an Excel file
New stock batches can be imported from an Excel file. A new import profile is available for this purpose.
Please contact TSD for more information about this powerful tool for managing stocks.
Create price requests for VARB directly from a sales line
When using the Treelinq II module, it is possible to generate price requests on the basis of VARB market stocks.
Price requests can now be generated from the Enquiry menu or via a sales order.
This can be done using the extra input field on the tab page Market of the Order Entry screen. If a quantity is entered here, the line will be saved in the application request lines, just as when inputting via Enquiry, and can be sent and processed from there.
Select addresses: clearer which address is being displayed (BASIC)
An extra description has been added to the drop-down list for selecting an address. This clearly shows which address type is being selected. This extension, which allows an address to be selected from a drop-down list, is available in all menus.
Split/move sales line - calculate prices adjustable (BASIC)
Parameter 2248 can be used to configure whether, when splitting/moving sales lines to a different customer, the ‘Recalculate prices’ checkbox has to be ticked on or off by default. The preferred value is for the checkbox to be ticked.
Use catalogue price in combination with basic price
Parameter 1709 could already be used to configure whether the sales price in a quote/sales order had to be determined on the basis of an existing stock list. This function has now been extended with parameter 2310. If this parameter is assigned value 1, the default sales price from the stock item in a sales line will be used if the selected article does not appear in the stock list.
Also display load when the order has been complete delivered
If you have put a sales order in delivery, the load in the sales order will no longer be visible. Parameter 2216 can now be used to configure whether the load has to be displayed based on the quantities to be supplied (default) or based on the full order quantities.
Extra information in selection list sales orders
In the Deliveries menu a drop-down list can be used to make a selection based on the available sales orders. The information per sales order has been extended in this list with the number of plants still to be supplied and their value.
Print address labels per delivery (BASIC)
A new label type known as 'Delivery header label' (document 415) is available in the Deliveries print group. This label can be printed from an open delivery or via File -> Print. You can print an address label using the delivery address.
You can now change the parameter for configuring the quantity of labels you wish to print, per batch. Use Parameter 1610 (value = 1).
Terms of payment: using @-codes to configure invoice text (BASIC)
You can now configure the texts you use for your invoices per payment condition. You can use @-codes similar to how you have been compiling invoice footer texts previously, but now they can be used to configure more texts for your various payment conditions. The invoice text from the payment condition used is recorded in the invoice footers using @8.
Terms of payment: extra option for determining the invoice expiry date (BASIC)
The terms of payments contains various options for determining the invoice expiry date. The existing options have been expanded to include the setting ‘Cond. Exp.date rounded off to the end of the month’. Even if the invoice expiry date falls on the first of the month it will still be rounded off to the end of the month.
Example: invoice date 3-10-2014, expiry date 45 days. On the basis of the new option the expiry date of this invoice will then be 3-10 + 45 = 17-11, so when rounded off this will be 30-11.
Using two new check boxes in the export wizard, it is now possible to export the customer and supplier information directly to an external book-keeping programme during the export of the sales invoices. Previously this had to be done separately via the File --> Export menu. (This method is still available)
Supplier offers; mutable sales prices
Parameter 2283 can be used to configure the sales price column so that is visible in the Purchase -> Supplier offers -> Maintenance menu. The amounts in this column can also be changed in this screen.
Inward goods: multiple new improvements
The following improvements have been implemented for the Inward goods menu:
1. Unprocessed lines can be left if [Process] is used. Can be configured via parameter 2223.
2. Entry date visible and mutable per line. Can be configured via parameter 2224.
Configuring this parameter moves the date at the bottom left of the screen to the receipt header/lines. The entry date goes to the batch itself. If the received quantity is changed (individually per line or more than one via the [All] button), the date at the bottom left of the screen is recorded as the entry date in the corresponding line(s). It goes without saying that this field is mutable per line (if the parameter is activated).
Note: if set to phase (par. 574) and the batch is allocated to an existing one, the entry date will not be adjusted.
3. Put received location back when receiving part quantities. Can be configured via parameter 2226.
Configuring this parameter means that the first change in the line will cause the values of the mutable fields to be saved in a work chart. If a part quantity is then received, the batch being delivered with the remainder will retrieve the values from this chart and put them back in the batch which is under way. This means the location, cost price, text, date_ready, row, rp_code, purchase_as_own, text_external, entry_date and phase fields. When closing the screen the lines created in the work chart will be deleted for the registered user.
Supplier offers: 'Only cheapest' option, also on the basis of PCP
The menu Purchase -> Supplier offers -> Maintenance includes a checkbox 'Only cheapest'. Parameter 2240 can be used to configure whether the cheapest lines have to be set according to the cost price or the PCP (= Purchase Cost Price).
Size of tab page Contacts Increased (Basic)
The size of the tab page Contacts of the Maintain Contacts screen has now been increased.
Fields have been moved to create more work-space, as well as to allow for future developments.
Employees: alternative e-mail addresses (BASIC)
In the employee data it is possible, besides the default e-mail address, to record an alternative address for the Sender and the BCC. These fields are only available if the e-mails are sent using SMTP.
If parameter 1393 is configured to value ABC, the alternative address from the employee table will be used as the sender address. If this field is empty, the employee's default e-mail address will be used.
The BCC is determined by looking to see whether the employee has submitted an alternative E-mail BCC address. If an address is available here, that address will be used. If this field is empty, the employee's default e-mail address will be used. If no e-mail addresses have been entered for the employee, the address from parameter 1247 will be used.
Header and Footer texts, adopt from basic information from current sales order (BASIC)
When compiling the header and footer texts and the e-mail text, an extra checkbox 'Copy this text…' is available in conjunction with the following type of documents: Call-up list, Picking list, Delivery Note and Invoice. By default this checkbox (value saved in parameter 1831) is ticked.
If the checkbox is ticked, the header and footer texts of, for example, the Delivery note will be copied into the delivery note from the sales order. If the text for the delivery note has been changed in the basic information, after the sales order was already booked, the old text for the delivery note will therefore be used. If the checkbox is not ticked, the texts will be taken directly from the basic information when creating the delivery note. In this way, therefore, the last text entered from the basic information will always be used when printing.
Note: if the checkbox has not been selected, there is, therefore, no point entering, for example, an adapted text for the delivery note in the sales order. When creating the delivery note, this will then be overwritten by the default from the basic information.
The options for sending information to a contact can now be set to fax and e-mail. As a result, preferences can be configured for how the document should be sent. Should both options be ticked for the contact and the document, the document will be sent by e-mail.
If, in Maintain Contacts -> tab page Communication a contact person is linked to a document, the output preference can be changed again per document. This document setting per contact overrules the general preferences of the contact and the document.
Dashboard within WinTree (BASIC)
2015 will be a trial year for TSD for this new function. At present TSD has compiled 3 graphics for the new dashboard:
1. a weekly overview of invoiced values, whereby the different years can be compared (line graph).
2. an overview of the sale values of the current season divided into Approved, On order, Delivered and Invoiced (doughnut chart)
3. an overview of the top 10 best selling article groups (bar chart).
Please contact TSD if you would like to install this functionality. This will help TSD gain experience during its initial implementation in 2015. At the end of the year, TSD will evaluate the trial using your contributions as WinTree users and hopefully increase /improve the number of graphs. Contact TSD if you want to take part in this trial. This involves installing a small additional program to enable the new dashboard and display statistical information as graphs.
Allocation screen: more lines visible in top part of the screen (BASIC)
9891
The top part of the allocation screen now has a default space to display 6 allocated lines directly.
In the past, managing documents was often a question of printing and careful archiving. These days more and more documents are being sent directly by fax or e-mail. In addition, customers and suppliers are sending documentation in digital form. This has also led to an increased need for a good system for archiving all these documents digitally and in which it is easy to retrieve documents. Generally, programs which can fulfil this need are costly and, what is more, these systems cannot be easily linked to WinTree. For this reason, TSD has developed an Archive System. This program fulfils the basic requirements as regards archiving and search options.
Please contact TSD if you would like to start using this function.
Save details of the employee who input the order (BASIC)
If Wintree is started up with a unique user, this user will be recorded automatically in the database for the booking of quotes, sales orders, purchase orders and when generating delivery notes and invoices. This user will not be changed even if a different user makes a change in, for example, a quote made by their colleague. A printer setting makes it possible to print off this user’s name, with the date and time on each of the relevant documents.
The properties (right mouse button, Properties option) of the Create e-mail and Send Mailing menus can be configured so that the selected letter is sent as PDF attachment.
Using schedule to copying revenue details
The module Revenue Statistics (206) makes it possible to copy revenue details from Nursery Manager to Office Manager. This data can be used as selection criteria when making selections. These revenue details must be copied manually. It is now also possible to have this data retrieved via a schedule.
Please contact TSD if this schedule has to be activated.
Quotes also available as revenue value
Besides the sale, purchase and invoiced value, the quote value is now also included when copying the revenue statistics from Nursery Manager to Office Manager.
Task overview shows more information of documents from Nursery Manager (BASIC)
When printing a quote, sales confirmation and invoice from Nursery Manager, the program can now be configured so that a task can be recorded directly in the Office Manager business agenda. The data in this task has been expanded to include the quote/sales order/invoice number, the reference and the header text. What is more, a direct (blue-coloured) link to the document is available in the task.
Export selection of addresses to Google maps (BASIC)
Google Maps includes an option to save a map under an individual account. You can save flags on this map (places, with names). The list of address to be marked can be imported.
An export file can be generated from a selection which can then be imported into Google Maps. A maximum of 100 lines can be imported into a free Google Account. If the selection contains more than 100 lines, a notification will be displayed with the question of whether the user has Google Pro. If a user has this paid account, 2000 addresses can be imported.
The export option is available in the menu Maintain -> Compose selection-. Tab page Result -> [Actions].
C&C screen; sorting can be configured
Parameter 2270 can be used to configure the program so that the sequence of the lines in the C&C menu according to scan sequence (= input sequence) or the default sequence of normal sales orders (usually plant sequence number, size sequence number) has to be used.